package org.mybatis.spring.boot.study.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.mybatis.spring.boot.study.entity.TjsUser;

/**
 * @author nicky
 * @date 2021/9/1 上午11:11
 */
@Mapper
public interface TjsUserMapper/* extends BaseMapper<TjsUser>*/ {

    @Select("select id, name, state, country from tjs_user where state = #{state}")
    TjsUser findByState(@Param("state") String state);
}
